Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerOrderID (PK) | A unique system assigned identifier for the CustomerOrder. | ID_ORD | Identity | integer | |
CustomerOrderTypeCode (FK) | A unique retailer assigned code denoting a type of CustomerOrder Examples include: LAYAWAY ORDER FOR DELIVERY ORDER FOR PICKUP Eg: Layaway, Order for Delivery, Order for Pickup, etc... | CD_TYP_CTORD | Code2 | char(2) | CustomerOrderType(CO_TYP_CTORD) |
EstimatedAvailabilityDate | The date the merchandise being ordered is expected to be available for delivery to the Customer or pickup by the Customer. | DC_AVLB_EST | DateCalendar | date | |
ActualAvailabilityDate | The date all the merchandise being ordered was made available for delivery to the Customer or pickup by the Customer. Where the merchandise becomes available over a period of time - this field holds the date the last ordered product was available for delivery or pickup. | DC_AVLB_ACT | DateCalendar | date | |
CustomerID (FK) | A unique system assigned identifier for the Customer. | ID_CT | Identity | integer | Customer(PA_CT) |
SpecialOrderID | An separate identifier (from that of a customer order id) for a special order | ID_ORD_SPL | IdentityAlphaNumeric | varchar(20) | |
ChannelID (FK) | Token Identifier for a channel instance | ID_CHNL | Identity | integer | Channel(CO_CHNL) |
ISOCurrencyCode (FK) | Currency code designated by ISO to identify national currency | CD_CNY_ISO_4217 | ISO_4217_CurrencyCode_char(3) | char(3) | ISO4217-CurrencyType(LU_CNY_ISO_4217) |
CustomerAccountID (FK) | A unique identifier for a customer account. | ID_CTAC | Identity | integer | CustomerOrderAccount(LE_CT_ORD_ACNT) |